/*==============================================================*/
/* Table: SYS_CONFIG_INFO                                       */
/*==============================================================*/
CREATE TABLE SYS_CONFIG_INFO
(
   ID                   VARCHAR(32)         NOT NULL,
   CONFIG_NAME          VARCHAR(100)        NOT NULL,
   CONFIG_KEY           VARCHAR(100)        NOT NULL,
   CONFIG_VALUE         VARCHAR(100)        NOT NULL,
   CONFIG_TYPE          int8            DEFAULT 0,
   CREATE_BY            VARCHAR(64)         NOT NULL,
   CREATE_TIME          DATE DEFAULT CURRENT_DATE NOT NULL,
   UPDATE_BY            VARCHAR(64)         NOT NULL,
   UPDATE_TIME          DATE DEFAULT CURRENT_DATE NOT NULL,
   REMARK               VARCHAR(500),
   CONSTRAINT PK_SYS_CONFIG_INFO PRIMARY KEY (ID)
);

COMMENT ON TABLE SYS_CONFIG_INFO IS '参数配置表';
COMMENT ON COLUMN SYS_CONFIG_INFO.CONFIG_NAME IS '配置名称';
COMMENT ON COLUMN SYS_CONFIG_INFO.CONFIG_KEY IS '配置键';
COMMENT ON COLUMN SYS_CONFIG_INFO.CONFIG_VALUE IS '配置键值';
COMMENT ON COLUMN SYS_CONFIG_INFO.CONFIG_TYPE IS '配置类型';
COMMENT ON COLUMN SYS_CONFIG_INFO.CREATE_BY IS '创建者';
COMMENT ON COLUMN SYS_CONFIG_INFO.CREATE_TIME IS '创建时间';
COMMENT ON COLUMN SYS_CONFIG_INFO.UPDATE_BY IS '更新者';
COMMENT ON COLUMN SYS_CONFIG_INFO.UPDATE_TIME IS '更新时间';
COMMENT ON COLUMN SYS_CONFIG_INFO.REMARK IS '备注';

@DELIMITER %%% ;
/** FUNCTION,如果用dbvisualizer,   需要添加下面所有的注释掉的行 （一共3行）                                    */
/**   */

create or replace FUNCTION GENTABID(in js1 int,inout res1 int,out res2 int) as
$$
begin
   res1:=js1*2;
     res2:=res1*3;
end;
$$
@DELIMITER ; %%%
